UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1167zBx/KasvqsEtvOxIcqoCMnMvdFO1T9E96KIcvA='
WHERE
key_id = '7a8f95d7b9629b2345c808bbf0601d23418f73c5f0ecb714c5c3706ddc369a0d'
AND (
token = 'k1167zBx/KasvqsEtvOxIcqoCMnMvdFO1T9E96KIcvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)