UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YjO3xWwgxX5p+FAHXoH120zMwAIWgCRS6SpJFyO7N4='
WHERE
key_id = '5dc2432c9761710d8cce638bb2be9348258b152190eec4c2b3896eda286fbd04'
AND (
token = '8YjO3xWwgxX5p+FAHXoH120zMwAIWgCRS6SpJFyO7N4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)