UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xEG60zBxWlUEjOBM11epEfI2nVfWTFaIdGp6urCXjCw='
WHERE
key_id = '0228e65672f3f189f2b30be8775e0b11578548242a11d3ebe9dd6ee76205e288'
AND (
token = 'xEG60zBxWlUEjOBM11epEfI2nVfWTFaIdGp6urCXjCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)