UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c0veoqvWs6N/iPQrjFtOOxU+WYTciBmbhjyaScPTxYM='
WHERE
key_id = 'c59df708f4e3731516fe711db2b6f3ac339b125c92c768087133df5093be57ae'
AND (
token = 'c0veoqvWs6N/iPQrjFtOOxU+WYTciBmbhjyaScPTxYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)