UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wvdQKbsWeTrOZ+rLZ00MgbD9VMg/1mRSfT4Oiwos28='
WHERE
key_id = 'c5a47f9775f43740fc65af658a5812c8de42b0d1f2b1032f30a00195d397f743'
AND (
token = '9wvdQKbsWeTrOZ+rLZ00MgbD9VMg/1mRSfT4Oiwos28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)