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