UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DkqXmZ6H5rdMSZg54Ma0sNLdCZ/avT60wNVSf/7J0Vg='
WHERE
key_id = 'bc34d46645801249fb0075493e272bb4aeaebddec1ff57b28272d34ce4bae18f'
AND (
token = 'DkqXmZ6H5rdMSZg54Ma0sNLdCZ/avT60wNVSf/7J0Vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)