UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kfnWVPE8ZOhPfj86j7eTZNh9wQgAnVo0xBHjexF3BE4='
WHERE
key_id = '1bea2468d3d77967a57234cb3be9677715e0198c47b8df03f7bd7bded13e6948'
AND (
token = 'kfnWVPE8ZOhPfj86j7eTZNh9wQgAnVo0xBHjexF3BE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)