UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NM0SShO7eEh1p6ytPJiYGV+UUk0xpg5f/A+qtX1AiU8='
WHERE
key_id = '7012287c44670578f49efb573a9e2fa0f6ed5a2f3cb2edb5ad269edad77fe575'
AND (
token = 'NM0SShO7eEh1p6ytPJiYGV+UUk0xpg5f/A+qtX1AiU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)