UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4FgUjLge8g1vNois8u1BC/LcKFo4Ly8ugH0KMcQFFU='
WHERE
key_id = '4d6de1abb377584d4a136d772ae7847181762e972023f6e776b374c99d922dbc'
AND (
token = 'd4FgUjLge8g1vNois8u1BC/LcKFo4Ly8ugH0KMcQFFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)