UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KYD+s7HCJfwtrloM7+V5H1Qr4uc2WGwifkPXErtindo='
WHERE
key_id = '6de4ef849a1c33bd9da2885e918c75f577038d9d5208900d1563dd9608ed249e'
AND (
token = 'KYD+s7HCJfwtrloM7+V5H1Qr4uc2WGwifkPXErtindo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)