UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qnxngkQT1TAbVrNK8F8u05g11IodGkwyYZu9warUto='
WHERE
key_id = 'cdbb8be3974cb6d16cee581f3b0cf393fa40618f785a3519c75176ab22c151cf'
AND (
token = '8qnxngkQT1TAbVrNK8F8u05g11IodGkwyYZu9warUto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)