UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p1lP1gniKEysAGWQNmgJ4R45jN4ZDWnXPgLNpF55UHU='
WHERE
key_id = '4b4197eaefbe7074a5ff5489e65ba7bbfb5ce4681d35d1f88db9a263a92b1d93'
AND (
token = 'p1lP1gniKEysAGWQNmgJ4R45jN4ZDWnXPgLNpF55UHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)