UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oBKc1PWJ0Hde+ZtwhT53Xs5QGByhsyUnXjPmmvidgME='
WHERE
key_id = 'a22446574785cafbd21a4201d2c91d5b27366232a044a4ef716147c1874f171f'
AND (
token = 'oBKc1PWJ0Hde+ZtwhT53Xs5QGByhsyUnXjPmmvidgME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)