UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkJsGVTYieDpWKdqzbIQzL5V1hLuNyjHliDssVbOttc='
WHERE
key_id = 'c20e7a2f014bc40a5c735745e09f270cd2c5bec0a0eb57c16d4c5dfc4718d587'
AND (
token = 'zkJsGVTYieDpWKdqzbIQzL5V1hLuNyjHliDssVbOttc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)