UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6HCvaOVaxNkbuRDC21azyAey7KRMXoPTI+GSZ2waKE='
WHERE
key_id = '8f73cba96d7cf3fbcbb582c95d06214083773844665d8eb16ed4cd408c8da8a1'
AND (
token = 'K6HCvaOVaxNkbuRDC21azyAey7KRMXoPTI+GSZ2waKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)