UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aJ+6tQEJ71tYgg7X6+aREWOcDIdC8yajFDaCp2WWUzY='
WHERE
key_id = '520541909038f723c411c5c7d31da51d5c8c44486b563539f5e35e6971c99818'
AND (
token = 'aJ+6tQEJ71tYgg7X6+aREWOcDIdC8yajFDaCp2WWUzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)