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