UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cDTTDYwJY7ETkuhLPmNJzh1qgNE7hZwoeS961Chg7Q8='
WHERE
key_id = '9499d0f53724dca21b8e7bea6a770e870b659125a9bc20b7bd95520912479288'
AND (
token = 'cDTTDYwJY7ETkuhLPmNJzh1qgNE7hZwoeS961Chg7Q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)