UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sP58jI6h6lKKwfjSLKU/gnNgTbI2Eor0pvTre+fYIFA='
WHERE
key_id = '0ccb2ca348a355fdc46b733e02bb89b0a33de32b6af1608dc72d419e08b6b9cb'
AND (
token = 'sP58jI6h6lKKwfjSLKU/gnNgTbI2Eor0pvTre+fYIFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)