UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6fQHTTBLEiyAu59Y0kTfLK6M3Ykhzu5VjDaKCaNfdEM='
WHERE
key_id = 'e4cd2eac0cc393157d20ca21c9c3012f2db1b8ddb271a01734794d81eac6c66d'
AND (
token = '6fQHTTBLEiyAu59Y0kTfLK6M3Ykhzu5VjDaKCaNfdEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)