UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xlC0a0lcFi2Z5jp1PsM49kr1uUKISKSgOILscckjMMc='
WHERE
key_id = 'e17e7e32188a00df239d18a3b80591c16c7b67a13ad8ebbd6b11dae074fa61ac'
AND (
token = 'xlC0a0lcFi2Z5jp1PsM49kr1uUKISKSgOILscckjMMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)