UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PJN5eq1ZWLZY5+W/e5skgvT7W+iQlCcJdiLjUwxl72Y='
WHERE
key_id = '4c196f6c3fbecf246f092bb8a5ce7614f784ce8ca53fbed9eeaebccd5c88931a'
AND (
token = 'PJN5eq1ZWLZY5+W/e5skgvT7W+iQlCcJdiLjUwxl72Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)