UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RgyYK7u1euzEMi9gAQVUYYAo8ljBAoj/tj+Q/dVzwbk='
WHERE
key_id = '9c30d8d64c6c28819c51aad4a5302fc54c3805aefee89fe40e8b098b57c96422'
AND (
token = 'RgyYK7u1euzEMi9gAQVUYYAo8ljBAoj/tj+Q/dVzwbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)