UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DYi3J9LwO7HGJhodqqS2ck7+CCPbP1snfFmj+tT99Fs='
WHERE
key_id = 'f58e8c7e0063b6946aa8cb98a20391f1d37773c494a59940bae0f985bab99d8c'
AND (
token = 'DYi3J9LwO7HGJhodqqS2ck7+CCPbP1snfFmj+tT99Fs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)