UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zpPRfQJ0PGHz6qXKN6U9rvXIule6dAC1Hi3difdCoU='
WHERE
key_id = '855560972170d1179985e814fdf5b57e4a9fe33f5fd14ea7877f5ac3436c8baf'
AND (
token = '5zpPRfQJ0PGHz6qXKN6U9rvXIule6dAC1Hi3difdCoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)