UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5P9ClQsZYEKsLUMujkMv/EGocfBNzt4zznpmnI9JpR0='
WHERE
key_id = '9b4ac9ae30e819d52539c2fe7d04ffa828e802b877d9f09d8c1af542209539f2'
AND (
token = '5P9ClQsZYEKsLUMujkMv/EGocfBNzt4zznpmnI9JpR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)