UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1G/c6xzNJyet63ySBnnBDggZsJex7WlPsreVCXmi6ZU='
WHERE
key_id = 'b1c8d144ba8e8a3309318890a5156646b28874e97e6c1e60604d01eb495768e2'
AND (
token = '1G/c6xzNJyet63ySBnnBDggZsJex7WlPsreVCXmi6ZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)