UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zvi6zjHdkdkZe7dtMFkx49+BFBKQVaVFNX6NOhvNGXE='
WHERE
key_id = 'e0c50f040985b111e3082662a0661745c75eb963d1719cdd2865d12c076638be'
AND (
token = 'Zvi6zjHdkdkZe7dtMFkx49+BFBKQVaVFNX6NOhvNGXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)