UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2P7Rk15tGxsnsirarqiPV88UvQfRItJpNBMU+ULyRIE='
WHERE
key_id = 'df31257c8ee6eac82ed8308049ee653ff4251f5011f9a8437b0a08d373c3cbb1'
AND (
token = '2P7Rk15tGxsnsirarqiPV88UvQfRItJpNBMU+ULyRIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)