UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2j0FQ6jYJTNdHyLHmZXOpZWpvS3QB6f2+L8MlOtV6+w='
WHERE
key_id = '402983abc9d1f17445d9b36c7f219f9cbcbf5a969d8008dad9a178598edf7e65'
AND (
token = '2j0FQ6jYJTNdHyLHmZXOpZWpvS3QB6f2+L8MlOtV6+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)