UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ynIE5k35uYG6HKbAyJ1dBX3+h6psmmgMm6gtEN7l/CI='
WHERE
key_id = '305dd43f3a630903660f6fe4f49bf3589150f62f4a7bacb6cf1d4c5d9ad47a97'
AND (
token = 'ynIE5k35uYG6HKbAyJ1dBX3+h6psmmgMm6gtEN7l/CI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)